select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and b.propertytype = 4 and (a.houseArea >= 100 and a.houseArea <= 200) and c.enDistrictName = 'Changning' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Zhongshan Park') order by updateTime Desc, a.dftpic desc
good location,nice in&out door pool,provide nice and professional service, house keeping three times per week,towel changing twice per week and bedding changing...
With balcony, fully furnitured,walking distance to subway, with large living room,very comfortable living environment,please confirm with our property consultan...